Release 10.1A: OpenEdge Data Management:
SQL Reference

ADD_MONTHS

Adds to the date value specified by the date_expression, the given number of months specified by integer_expression, and returns the resultant date value.

Syntax

ADD_MONTHS ( date_expression , integer_expression )

Example

This example illustrates the ADD_MONTHS function:

SELECT *     FROM customer     WHERE ADD_MONTHS (start_date, 6) > SYSDATE ;

Notes

The first argument must be of DATE type.
The second argument to the function must be of NUMERIC type.
The result is of type DATE.
If any of the arguments evaluates to NULL, the result is NULL.

Compatibility

Progress extension